package com.visiontech.volunteer_center.mapper;

import com.visiontech.volunteer_center.pojo.Content_LFRX;
import com.visiontech.volunteer_center.pojo.Content_WMSX;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface ContentMapper {
    public List<Content_WMSX> showContents_wmsx();

    public List<Content_WMSX> findByTitle_wmsx(@Param("title") String title);

    public Integer deleteById_wmsx(@Param("wmsx_id") Integer wmsx_id);

    public Integer updateById_wmsx(@Param("wmsx_id") Integer wmsx_id, @Param("title") String title,
                                   @Param("link")String link, @Param("photo")String photo);

    public Integer insertWMSX(@Param("title")String title, @Param("link")String link,  @Param("photo")String photo);

//  ===================================================================================================================

    public Integer insertLFRX(@Param("name")String name, @Param("sex")String sex, @Param("phone") String phone,
                              @Param("email")String email, @Param("address")String address, @Param("text")String text);

    public List<Content_LFRX> showLFRXContents();

    public Content_LFRX findById(@Param("lfrx_id") Integer lfrx_id);

    public List<Content_LFRX> findByName(@Param("lfrx_name") String lfrx_name);

    public List<Content_LFRX> findLFRX(@Param("lfrx_id") Integer lfrx_id, @Param("lfrx_name") String lfrx_name);

    public Integer deleteById_lfrx(@Param("lfrx_id") Integer lfrx_id);
}
